﻿SELECT P.idPath,
CONVERT(UNHEX(HEX(CONVERT(CONVERT(P.strPath USING utf8) USING latin1))), CHAR) AS strPath,
F.idFile,
CONVERT(UNHEX(HEX(CONVERT(CONVERT(F.strFilename USING utf8) USING latin1))), CHAR) AS strFilename
FROM files AS f
INNER JOIN path AS P ON P.idPath = F.idPath;
